CREATING A MAP
1. Click the chart that was
just created and press on your keyboard ctrl+c to copy, then press ctrl+v to
paste.
2. Drag Over COUNTY to
location
3. Drag Average of END_LAT to
Latitude (click arrow and choose average)
4. Drag Average of END_LON to
Longitude (click arrow and choose average)
5. Drag Total Tornadoes to
Tooltips
6. Click paint brush
Data Colors
1. Click the fx
2.
Click Based on field and input Count of END_LOCATION
3.
Click diverging
4.
Minimum color #56BDFF
5.
Center color #009DFF
6.
Maximum color #0054A8
Map Styles
1. Theme LIGHT
Title
1. Tornadoes Location In TX
CREATING MAP LEGEND
1. Click the chart that was just created and press on your keyboard ctrl+c to copy, then press ctrl+v to paste on new page.
2. Click the + sign at the bottom of the page so you will have a blank page to work on.
3. Once you paste the map change it to a scatter chart.
4. Now try your best to screenshot the legend of the scatter chart at the bottom.
5. Save picture to location in computer of choice.
6. Now click the insert tab at the top left of page.
7. Click the image icon on the far top right of page.
8. Select image then click open.
9. Resize by dragging corners of legend.
10. Click insert at the top left of page.
11. Click the shapes icon next to the image icon and choose the square.
12. If the square has color click format shape, Fill, then make the color white.
13. Make square smaller and place legend inside square.
14. Click Format at top of the screen and click Send backward.
15. Click insert then Text box at the top right of page.
16. Choose font Arial Black type Low and resize box and place text under left side of legend.
17. Choose font Arial Black type High and resize box and place text under right side of legend.
18. Hold shift and click all 4 objects.
19. Click format at the top of the screen then click group twice (top right of screen).
20. Click the legend that was just created and press on your keyboard ctrl+c to copy, then press ctrl+v to paste on map.